package com.meiyou.mapper;

import com.meiyou.pojo.MeiyouYuehui;
import com.meiyou.pojo.MeiyouYuehuiExample;
import com.meiyou.pojo.YuehuiDetails;
import com.meiyou.pojo.vo.YuehuiApplyVo;
import com.meiyou.pojo.vo.YuehuiVo;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface MeiyouYuehuiMapper {
    int countByExample(MeiyouYuehuiExample example);

    int deleteByExample(MeiyouYuehuiExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(MeiyouYuehui record);

    int insertSelective(MeiyouYuehui record);
    
    YuehuiDetails selDetails(int yId);

    List<MeiyouYuehui> selectByExampleWithBLOBs(MeiyouYuehuiExample example);

    List<MeiyouYuehui> selectByExample(MeiyouYuehuiExample example);

    MeiyouYuehui selectByPrimaryKey(Integer yId);
    
    List<MeiyouYuehui> selectYueHui(MeiyouYuehui meiyouYuehui);
    
    List<YuehuiVo> selMyYuehui(String uCount); 
    
    List<MeiyouYuehui> selectAllYueHui(@Param("yUCount") String yUCount);
    
    List<YuehuiVo> selYuehuiVo(String yUcount);
    
    List<YuehuiVo> selYuehuiVoTerm(String yUcount,String ySex);
    
    MeiyouYuehui selYueHuiById(Integer yId);
    
    List<YuehuiApplyVo> selMyYhApply(String uCount);
    
    List<YuehuiVo> selYhask(int yId);
    
    @Select("SELECT y_assess FROM meiyou_yuehui WHERE y_id = #{yId}")
	int selYuehuiAssess(int yId);

    int updateByExampleSelective(@Param("record") MeiyouYuehui record, @Param("example") MeiyouYuehuiExample example);

    int updateByExampleWithBLOBs(@Param("record") MeiyouYuehui record, @Param("example") MeiyouYuehuiExample example);

    int updateByExample(@Param("record") MeiyouYuehui record, @Param("example") MeiyouYuehuiExample example);

    int updateByPrimaryKeySelective(MeiyouYuehui record);

    int updateByPrimaryKeyWithBLOBs(MeiyouYuehui record);

    int updateByPrimaryKey(MeiyouYuehui record);
    
    int updAssess(int yAssess,int yId);
}